USE [RD_SalesMart]
GO

/****** Object:  Index [PK_Sales_Star_FactsHdr]    Script Date: 05/21/2010 13:50:11 ******/
ALTER TABLE [dbo].[Sales_Star_FactsHdr] ADD  CONSTRAINT [PK_Sales_Star_FactsHdr] PRIMARY KEY CLUSTERED 
(
	[OrderNumber] ASC,
	[OrderTypeCode] ASC,
	[OrderNumberDocumentCompany] ASC,
	[OrderSuffix] ASC,
	[TransactionType] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO

/****** Object:  Index [IX_Facts_TransactionDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TransactionDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[TransactionDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_ActualDelDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_ActualDelDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[ActualDeliveryDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_CancelDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_CancelDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[CancelDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_DateActDel]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_DateActDel] ON [dbo].[Sales_Star_FactsHdr] 
(
	[DateActualDeliveryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_DateReqShip]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_DateReqShip] ON [dbo].[Sales_Star_FactsHdr] 
(
	[DateRequestedShipID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_FactsHdrID]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_FactsHdrID] ON [dbo].[Sales_Star_FactsHdr] 
(
	[FactsHdrID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_FutureUseDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_FutureUseDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[FutureUseDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_OPLatestLineDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_OPLatestLineDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[OPLatestLineDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_OriginalPromDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_OriginalPromDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[OriginalPromisedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_PaymentTermsID]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_PaymentTermsID] ON [dbo].[Sales_Star_FactsHdr] 
(
	[PaymentTermsID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_PriceEffDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_PriceEffDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[PriceEffectiveDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_PromisedDelDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_PromisedDelDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[PromisedDeliveryDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_RequestedDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_RequestedDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[RequestedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_ShipDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_ShipDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[ShipDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsHdr_UserReservedDate]    Script Date: 05/21/2010 13:50:05 ******/
CREATE NONCLUSTERED INDEX [IX_FactsHdr_UserReservedDate] ON [dbo].[Sales_Star_FactsHdr] 
(
	[UserReservedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


